Python Job: Data Warehouse Analyst

Job added on

Company

TransLink

Location

Vancouver - Canada

Job type

Full-Time

Python Job Details

Marketing Statement


A career at TransLink and our family of companies means working with people with a wide range of skills and perspectives, all teaming up towards a common goal: preserving and enhancing the region's world-envied quality of life. Together, we connect the region and enhance its livability by providing a sustainable transit and transportation network, embraced by our communities and people.

At TransLink we are dedicated to building a workforce that reflects the diversity of the communities in which we live. We’re committed to fostering an inclusive, equitable and accessible workplace, recognizing the unique value and skills every individual brings.

Looking for a great place to work where your contributions are valued and you can make a difference in a vibrant city? At TransLink, one of BC’s Top Employers, you'll help make Metro Vancouver a better place to live, built on transportation excellence. Put your future in motion!


Responsibilities




Works with stakeholders to analyse business requirements and offers technical expertise on Enterprise Data Warehousing (EDW) solutions. Designs, develops and implements EDW solutions to ensure the accessibility, functionality, integrity, and security of the data warehouse. Supports, maintains and optimizes EDW process and all related components. Researches development technologies and tools to support and improve the implementation of EDW strategies and business intelligence services.

Qualifications


EDUCATION:




Diploma in computer science from a recognized institute of technology including courses in database design, programming, business and systems analysis.






EXPERIENCE:




Requires three (3) years recent related experience in data warehousing, business intelligence, information management or analytics. Must have experience producing information products for clients with a variety of BI tools. A further period of up to one (1) year in the position is required to become familiar with Translink information systems, policies, procedures, environment and its user requirements, as well as corporate road maps and corporate data models.

Other Information


Peference will be given to candidates with extensive experience in
  • SSIS (SQL Server Integration Studio)
  • SSMS (SQL Server Management Studio)
  • SQL Server
Beneficial exprience includes:
  • Oracle PL/SQL
  • TOAD
  • SQL developer
  • Python
  • C#
  • Solar Winds Task Factory
Added advantage would be given to those with experience in;
  • Azure
  • Synapse
  • Azure Data Factory
  • DataBricks

Recruitment Process: An applicant will be required to demonstrate their suitability for this position by meeting the minimum level of qualifications and experience in order to be invited into the selection process. A standard interview format will be used including general, scenario and behavioural descriptive interview questions.

Work Schedule


37.5 hours per week.

Work Designation


Remote


This positions offers the ability to work predominately in a remote capacity within B.C. The business will request onsite presence at times for operational reasons.

Rate of Pay


Salary starting from: $7,255 - $8,725 per month. (Actual salary offered will be commensurate with education, experience and internal parity)


The Total Compensation Package includes Extended Health, Dental, Transit Pass and enrollment in the Public Service Pension Plan. Focus on your development through tuition reimbursement, training, and mentorship programs. Enjoy a variety of health and wellness programs, including access to gym facilities. Speak to us to know more about what we offer.


How to Apply


Please click the 'Apply' button at the top right corner of the page or go to http://www.translink.ca/careers to apply for this position and view instructions on the process.


INSTRUCTIONS: Please save your (1) cover letter, and your (2) resume as one pdf document prior to uploading your application on-line.


Posting Date: January 20, 2023
Closing Date: Open until filled.


Please note that only those short listed will be contacted.


Having trouble applying? Please view the System Requirements & FAQ's by going to http://www.translink.ca/careers.

Equal Employment Opportunity


TransLink is committed to employment equity and building a diverse workforce, representative of the customers we serve and the many communities in the Metro Vancouver region. We welcome and encourage Indigenous applicants, people of colour, all genders, 2SLGBTQ+ and persons with disabilities to apply. Learn more about TransLink's commitment to equity, diversity and inclusion.


Accommodations are available on request for candidates taking part in all aspects of the selection process. For a confidential inquiry, simply email us at [email protected].